﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DSAdmingas1" targetNamespace="http://tempuri.org/DSAdmingas1.xsd" xmlns:mstns="http://tempuri.org/DSAdmingas1.xsd" xmlns="http://tempuri.org/DSAdmingas1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="InfoVale" GeneratorFunctionsComponentClassName="InfoVale" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="InfoVale" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="AdmingasConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AdmingasConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Vales_Verificador_3.My.MySettings.GlobalReference.Default.AdmingasConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ValesEjercidosTableAdapter" GeneratorDataComponentClassName="ValesEjercidosTableAdapter" Name="ValesEjercidos" UserDataComponentName="ValesEjercidosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.Vales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select v.cliente as idc,(select top(1)  Nombre  as cliente from flotillas f where f.flotilla=v.cliente) as cliente,serie,impvale,min(id) as inicial,max(id) as final,count(impvale) as cantidad,(count(impvale)* impvale) as importe 
from vales v
where FechaSurtido &gt;= cast(@inicial as datetime) and FechaSurtido&lt; dateadd(dd,1,convert(datetime,@final)) and fechasurtido is not null 
group by v.cliente ,v.serie,v.impvale
order by v.cliente</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="inicial" ColumnName="FechaSurtido" DataSourceName="Admingas.dbo.Vales" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@inicial" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="FechaSurtido" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="final" ColumnName="FechaSurtido" DataSourceName="Admingas.dbo.Vales" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@final" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="FechaSurtido" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idc" DataSetColumn="idc" />
              <Mapping SourceColumn="cliente" DataSetColumn="cliente" />
              <Mapping SourceColumn="serie" DataSetColumn="serie" />
              <Mapping SourceColumn="impvale" DataSetColumn="impvale" />
              <Mapping SourceColumn="inicial" DataSetColumn="inicial" />
              <Mapping SourceColumn="final" DataSetColumn="final" />
              <Mapping SourceColumn="cantidad" DataSetColumn="cantidad" />
              <Mapping SourceColumn="importe" DataSetColumn="importe" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ValesVendidosTableAdapter" GeneratorDataComponentClassName="ValesVendidosTableAdapter" Name="ValesVendidos" UserDataComponentName="ValesVendidosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.Vales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillValesVendidos" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="TraerValesVendidos" GeneratorSourceName="FillValesVendidos" GetMethodModifier="Public" GetMethodName="TraerValesVendidos" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="TraerValesVendidos" UserSourceName="FillValesVendidos">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select DAY(v.FechaVenta) AS dia, MONTH(v.FechaVenta) AS mes, YEAR(v.FechaVenta) AS año, v.cliente,
(select Top(1) nombre from flotillas f where f.flotilla=v.cliente)as nombre,
v.serie, COUNT(v.Serie) AS cantidad, v.ImpVale AS denominacion,( select COUNT(v.Serie)  * v.ImpVale AS denominacion ) as Importe
from vales v
WHERE        (v.FechaVenta &gt;= cast(@inicial as datetime)) AND (v.FechaVenta &lt; dateadd(day,1,cast (@final as datetime))) 
group by  DAY(v.FechaVenta) , MONTH(v.FechaVenta) , YEAR(v.FechaVenta),v.cliente,v.serie,v.impvale
order by  DAY(v.FechaVenta) , MONTH(v.FechaVenta) , YEAR(v.FechaVenta),v.cliente,v.serie,v.impvale</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="inicial" ColumnName="FechaVenta" DataSourceName="Admingas.dbo.Vales" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@inicial" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="FechaVenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="final" ColumnName="FechaVenta" DataSourceName="Admingas.dbo.Vales" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@final" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="FechaVenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="dia" DataSetColumn="dia" />
              <Mapping SourceColumn="mes" DataSetColumn="mes" />
              <Mapping SourceColumn="año" DataSetColumn="año" />
              <Mapping SourceColumn="nombre" DataSetColumn="nombre" />
              <Mapping SourceColumn="cliente" DataSetColumn="cliente" />
              <Mapping SourceColumn="cantidad" DataSetColumn="cantidad" />
              <Mapping SourceColumn="denominacion" DataSetColumn="denominacion" />
              <Mapping SourceColumn="serie" DataSetColumn="serie" />
              <Mapping SourceColumn="Importe" DataSetColumn="Importe" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EncabezadoTableAdapter" GeneratorDataComponentClassName="EncabezadoTableAdapter" Name="Encabezado" UserDataComponentName="EncabezadoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.EncabTicket" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [encabTicket] ([ENCABEZADO1], [ENCABEZADO2], [ENCABEZADO5]) VALUES (@e1, @e2, @e3)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@e1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="e1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@e2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="e2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@e3" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="e3" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>select encabezado1 e1, encabezado2 e2, encabezado5 e3
from encabTicket</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="e1" DataSetColumn="e1" />
              <Mapping SourceColumn="e2" DataSetColumn="e2" />
              <Mapping SourceColumn="e3" DataSetColumn="e3" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EjercudoDisponibleTableAdapter" GeneratorDataComponentClassName="EjercudoDisponibleTableAdapter" Name="EjercudoDisponible" UserDataComponentName="EjercudoDisponibleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.Flotillas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [flotillas] ([flotilla], [nombre]) VALUES (@flotilla, @cliente)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@flotilla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="flotilla" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>select flotilla,nombre as cliente, isnull((select sum (v.ImpVale) from Vales v where v.cliente=f.flotilla group by cliente ),0) as TotalVendido,
isnull((select sum (v.ImpVale) from Vales v where v.cliente=f.flotilla and FechaSurtido    is not null  group by cliente ),0) as Totalsurtido
from flotillas f
join vales v on f.flotilla=v.cliente
group by f.flotilla,f.nombre
order by cast(flotilla as int), cliente
</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="flotilla" DataSetColumn="flotilla" />
              <Mapping SourceColumn="cliente" DataSetColumn="cliente" />
              <Mapping SourceColumn="TotalVendido" DataSetColumn="TotalVendido" />
              <Mapping SourceColumn="Totalsurtido" DataSetColumn="Totalsurtido" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientesConValesTableAdapter" GeneratorDataComponentClassName="ClientesConValesTableAdapter" Name="ClientesConVales" UserDataComponentName="ClientesConValesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.Flotillas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>select distinct c.flotilla,c.nombre from flotillas c  join vales v on v.cliente=c.flotilla
order by c.flotilla</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="flotilla" DataSetColumn="flotilla" />
              <Mapping SourceColumn="nombre" DataSetColumn="nombre" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ValesTableAdapter" GeneratorDataComponentClassName="ValesTableAdapter" Name="Vales" UserDataComponentName="ValesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.Vales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillNums" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataNums" GeneratorSourceName="FillNums" GetMethodModifier="Public" GetMethodName="GetDataNums" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataNums" UserSourceName="FillNums">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [vales] ([NumS], [FechaVenta], [FechaSurtido], [surtido], [Estado], [ImpVale], [serie], [cliente], [numvale]) VALUES (@NumS, @FechaVenta, @FechaSurtido, @surtido, @Estado, @ImpVale, @serie, @cliente, @numvale)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NumS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NumS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FechaVenta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaVenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FechaSurtido" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaSurtido" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@surtido" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="surtido" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ImpVale" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ImpVale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@serie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="serie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numvale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numvale" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select NumS, 
serie+'-' + CASE WHEN len(cliente)&lt;6  THEN right('000000'+cast(cliente as varchar(60)),6) ELSE cliente END +'-' 
+ CASE WHEN len(numvale)&lt;8  THEN right('000000'+cast(numvale as varchar(60)),8) ELSE cast(numvale as varchar(8)) END as Foliovale
,FechaVenta,FechaSurtido,surtido,Estado,ImpVale,serie,cliente,(select top(1) nombre from flotillas f where flotilla=v.cliente) as nombre,numvale,
(select sum(impvale)  from vales where surtido=1 and cliente=v.cliente) as totalsurtido,(select sum(impvale) from vales where surtido=0 and cliente=v.cliente) as  totalnosurtido
from vales v
WHERE (NumS = @nums)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="nums" ColumnName="NumS" DataSourceName="Admingas.dbo.Vales" DataTypeServer="nvarchar(11)" DbType="String" Direction="Input" ParameterName="@nums" Precision="0" ProviderType="NVarChar" Scale="0" Size="11" SourceColumn="NumS" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="NumS" DataSetColumn="NumS" />
              <Mapping SourceColumn="FechaVenta" DataSetColumn="FechaVenta" />
              <Mapping SourceColumn="FechaSurtido" DataSetColumn="FechaSurtido" />
              <Mapping SourceColumn="surtido" DataSetColumn="surtido" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
              <Mapping SourceColumn="ImpVale" DataSetColumn="ImpVale" />
              <Mapping SourceColumn="serie" DataSetColumn="serie" />
              <Mapping SourceColumn="cliente" DataSetColumn="cliente" />
              <Mapping SourceColumn="numvale" DataSetColumn="numvale" />
              <Mapping SourceColumn="nombre" DataSetColumn="nombre" />
              <Mapping SourceColumn="totalsurtido" DataSetColumn="totalsurtido" />
              <Mapping SourceColumn="totalnosurtido" DataSetColumn="totalnosurtido" />
              <Mapping SourceColumn="Foliovale" DataSetColumn="Foliovale" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.Vales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByClienteFechaVenta" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBylienteFechaVenta" GeneratorSourceName="FillByClienteFechaVenta" GetMethodModifier="Public" GetMethodName="GetDataBylienteFechaVenta" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBylienteFechaVenta" UserSourceName="FillByClienteFechaVenta">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT serie+'-' + CASE WHEN len(cliente)&lt;6  THEN right('000000'+cast(cliente as varchar(60)),6) ELSE cliente END +'-' + CASE WHEN len(numvale)&lt;8  THEN right('000000'+cast(numvale as varchar(60)),8) ELSE cast(numvale as varchar(8)) END as Foliovale, Estado, FechaSurtido, FechaVenta, ImpVale, NumS, NumVale, Serie, Surtido, cliente, (SELECT TOP (1) nombre FROM Flotillas AS f WHERE (flotilla = v.cliente)) AS nombre, (SELECT SUM(ImpVale) AS Expr1 FROM Vales AS Vales_1 WHERE (Surtido = 0) AND (cliente = v.cliente)) AS totalnosurtido, (SELECT SUM(ImpVale) AS Expr1 FROM Vales WHERE (Surtido = 1) AND (cliente = v.cliente)) AS totalsurtido FROM Vales AS v WHERE (CAST(FechaVenta AS datetime) &gt;= @inicial) AND (FechaVenta &lt; DATEADD(dd, 1, CONVERT (datetime, @Final)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="inicial" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="DateTime" Direction="Input" ParameterName="@inicial" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Final" ColumnName="FechaVenta" DataSourceName="Admingas.dbo.Vales" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Final" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="FechaVenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.Vales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDatosVale" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByDatosVale" GeneratorSourceName="FillByDatosVale" GetMethodModifier="Public" GetMethodName="GetDataByDatosVale" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByDatosVale" UserSourceName="FillByDatosVale">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Estado, FechaSurtido, FechaVenta, ImpVale, NumS, NumVale, Serie, Surtido, cliente FROM Vales AS v WHERE (Serie = @serie) AND (cliente = @cliente) AND (NumVale = @numvale)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="serie" ColumnName="Serie" DataSourceName="Admingas.dbo.Vales" DataTypeServer="nvarchar(2)" DbType="String" Direction="Input" ParameterName="@serie" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumn="Serie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="cliente" ColumnName="cliente" DataSourceName="Admingas.dbo.Vales" DataTypeServer="nvarchar(60)" DbType="String" Direction="Input" ParameterName="@cliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="60" SourceColumn="cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="numvale" ColumnName="NumVale" DataSourceName="Admingas.dbo.Vales" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@numvale" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="NumVale" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.Vales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByfolio" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByfolio" GeneratorSourceName="FillByfolio" GetMethodModifier="Public" GetMethodName="GetDataByfolio" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByfolio" UserSourceName="FillByfolio">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TOP (1) Estado, FechaSurtido, FechaVenta, Serie + '-' + CASE WHEN len(cliente) &lt; 6 THEN RIGHT ('000000' + CAST(cliente AS varchar(60)) , 6) ELSE cliente END + '-' + CASE WHEN len(numvale) &lt; 8 THEN RIGHT ('000000' + CAST(numvale AS varchar(60)) , 8) ELSE CAST(numvale AS varchar(8)) END AS Foliovale, ImpVale, NumS, NumVale, Serie, Surtido, cliente FROM Vales AS v WHERE (Serie = @serie) AND (cliente = @cliente) AND (NumVale = @numvale)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="serie" ColumnName="Serie" DataSourceName="Admingas.dbo.Vales" DataTypeServer="nvarchar(2)" DbType="String" Direction="Input" ParameterName="@serie" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumn="Serie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="cliente" ColumnName="cliente" DataSourceName="Admingas.dbo.Vales" DataTypeServer="nvarchar(60)" DbType="String" Direction="Input" ParameterName="@cliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="60" SourceColumn="cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="numvale" ColumnName="NumVale" DataSourceName="Admingas.dbo.Vales" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@numvale" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="NumVale" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.Vales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEscaneados" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataEscaneados" GeneratorSourceName="FillEscaneados" GetMethodModifier="Public" GetMethodName="GetDataEscaneados" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataEscaneados" UserSourceName="FillEscaneados">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Estado, FechaSurtido, FechaVenta, ImpVale, NumS, NumVale, Serie, Surtido, cliente, (SELECT SUM(ImpVale) AS Expr1 FROM Vales AS Vales_1 WHERE (Surtido = 0) AND (cliente = v.cliente)) AS totalnosurtido, (SELECT SUM(ImpVale) AS Expr1 FROM Vales WHERE (Surtido = 1) AND (cliente = v.cliente)) AS totalsurtido FROM Vales AS v WHERE (NumS IN (@nums))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="nums" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="@nums" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateFechaSurtido" Modifier="Public" Name="UpdateFechaSurtido" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="UpdateFechaSurtido">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE Vales set fechasurtido=@fechasurtido
where nums=@nums</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="fechasurtido" ColumnName="FechaSurtido" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fechasurtido" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="FechaSurtido" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="nums" ColumnName="NumS" DataSourceName="" DataTypeServer="nvarchar(11)" DbType="String" Direction="Input" ParameterName="@nums" Precision="0" ProviderType="NVarChar" Scale="0" Size="11" SourceColumn="NumS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateFechaVenta" Modifier="Public" Name="UpdateFechaVenta" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateFechaVenta">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE Vales set fechaventa=@fechaventa
where nums=@nums</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="fechaventa" ColumnName="FechaVenta" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fechaventa" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="FechaVenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="nums" ColumnName="NumS" DataSourceName="" DataTypeServer="nvarchar(11)" DbType="String" Direction="Input" ParameterName="@nums" Precision="0" ProviderType="NVarChar" Scale="0" Size="11" SourceColumn="NumS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateSurtido" Modifier="Public" Name="UpdateSurtido" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateSurtido">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE Vales set surtido=1 
where nums=@nums</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="nums" ColumnName="NumS" DataSourceName="" DataTypeServer="nvarchar(11)" DbType="String" Direction="Input" ParameterName="@nums" Precision="0" ProviderType="NVarChar" Scale="0" Size="11" SourceColumn="NumS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InfoValeTableAdapter" GeneratorDataComponentClassName="InfoValeTableAdapter" Name="InfoVale" UserDataComponentName="InfoValeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.Vales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillInfoVale" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataInfovale" GeneratorSourceName="FillInfoVale" GetMethodModifier="Public" GetMethodName="GetDataInfovale" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataInfovale" UserSourceName="FillInfoVale">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [vales] ([nums], [FechaVenta], [FechaSurtido], [Surtido], [ImpVale], [serie], [numvale], [surtido]) VALUES (@nums, @FechaVenta, @FechaSurtido, @surti, @ImpVale, @serie, @numvale, @surtido)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nums" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nums" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FechaVenta" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaVenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FechaSurtido" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaSurtido" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@surti" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="surti" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ImpVale" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ImpVale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@serie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="serie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numvale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numvale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@surtido" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="surtido" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select serie+'-' + CASE WHEN len(cliente)&lt;6  THEN right('000000'+cast(cliente as varchar(60)),6) ELSE cliente END +'-' 
+ CASE WHEN len(numvale)&lt;8  THEN right('000000'+cast(numvale as varchar(60)),8) ELSE cast(numvale as varchar(8)) END as Foliovale
,nums,FechaVenta,FechaSurtido,surtido as surti ,ImpVale,serie,(select top(1) nombre from flotillas f where f.flotilla=v.cliente) as cliente,numvale,surtido from vales v
WHERE (Serie = @serie) AND (cliente = @cliente) AND (NumVale = @numvale)


</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="serie" ColumnName="Serie" DataSourceName="Admingas.dbo.Vales" DataTypeServer="nvarchar(2)" DbType="String" Direction="Input" ParameterName="@serie" Precision="0" ProviderType="NVarChar" Scale="0" Size="2" SourceColumn="Serie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="cliente" ColumnName="(SELECT TOP (1) nombre FROM Flotillas AS f WHERE (flotilla = v.cliente))" DataSourceName="" DataTypeServer="nvarchar(60)" DbType="String" Direction="Input" ParameterName="@cliente" Precision="0" Scale="0" Size="60" SourceColumn="cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="numvale" ColumnName="NumVale" DataSourceName="Admingas.dbo.Vales" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@numvale" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="NumVale" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nums" DataSetColumn="nums" />
              <Mapping SourceColumn="FechaVenta" DataSetColumn="FechaVenta" />
              <Mapping SourceColumn="FechaSurtido" DataSetColumn="FechaSurtido" />
              <Mapping SourceColumn="ImpVale" DataSetColumn="denominacion" />
              <Mapping SourceColumn="serie" DataSetColumn="serie" />
              <Mapping SourceColumn="cliente" DataSetColumn="cliente" />
              <Mapping SourceColumn="numvale" DataSetColumn="numvale" />
              <Mapping SourceColumn="surtido" DataSetColumn="surtido" />
              <Mapping SourceColumn="surti" DataSetColumn="surti" />
              <Mapping SourceColumn="Foliovale" DataSetColumn="Foliovale" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="AdmingasConnectionString (MySettings)" DbObjectName="Admingas.dbo.Vales" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="ScalarQuery" MethodsParameterType="CLR" Modifier="Public" Name="ScalarQuery" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="ScalarQuery">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>select NumS, serie+'-'+right('000000'+cast(cliente as varchar(20)),6)+'-'+right('0000000'+cast(numvale as varchar(20)),7) as FolioVale,nums,FechaVenta,FechaSurtido,FechaVenta,surtido,Estado,ImpVale,serie,cliente,numvale from vales v</CommandText>
                <Parameters />
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DSAdmingas1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DSAdmingas1" msprop:Generator_UserDSName="DSAdmingas1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ValesEjercidos" msprop:Generator_TableClassName="ValesEjercidosDataTable" msprop:Generator_TableVarName="tableValesEjercidos" msprop:Generator_RowChangedName="ValesEjercidosRowChanged" msprop:Generator_TablePropName="ValesEjercidos" msprop:Generator_RowDeletingName="ValesEjercidosRowDeleting" msprop:Generator_RowChangingName="ValesEjercidosRowChanging" msprop:Generator_RowEvHandlerName="ValesEjercidosRowChangeEventHandler" msprop:Generator_RowDeletedName="ValesEjercidosRowDeleted" msprop:Generator_RowClassName="ValesEjercidosRow" msprop:Generator_UserTableName="ValesEjercidos" msprop:Generator_RowEvArgName="ValesEjercidosRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idc" msprop:Generator_ColumnVarNameInTable="columnidc" msprop:Generator_ColumnPropNameInRow="idc" msprop:Generator_ColumnPropNameInTable="idcColumn" msprop:Generator_UserColumnName="idc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cliente" msprop:Generator_ColumnVarNameInTable="columncliente" msprop:Generator_ColumnPropNameInRow="cliente" msprop:Generator_ColumnPropNameInTable="clienteColumn" msprop:Generator_UserColumnName="cliente" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="serie" msprop:Generator_ColumnVarNameInTable="columnserie" msprop:Generator_ColumnPropNameInRow="serie" msprop:Generator_ColumnPropNameInTable="serieColumn" msprop:Generator_UserColumnName="serie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="impvale" msprop:Generator_ColumnVarNameInTable="columnimpvale" msprop:Generator_ColumnPropNameInRow="impvale" msprop:Generator_ColumnPropNameInTable="impvaleColumn" msprop:Generator_UserColumnName="impvale" type="xs:decimal" minOccurs="0" />
              <xs:element name="inicial" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columninicial" msprop:Generator_ColumnPropNameInRow="inicial" msprop:Generator_ColumnPropNameInTable="inicialColumn" msprop:Generator_UserColumnName="inicial" type="xs:int" minOccurs="0" />
              <xs:element name="final" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnfinal" msprop:Generator_ColumnPropNameInRow="final" msprop:Generator_ColumnPropNameInTable="finalColumn" msprop:Generator_UserColumnName="final" type="xs:int" minOccurs="0" />
              <xs:element name="cantidad" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncantidad" msprop:Generator_ColumnPropNameInRow="cantidad" msprop:Generator_ColumnPropNameInTable="cantidadColumn" msprop:Generator_UserColumnName="cantidad" type="xs:int" minOccurs="0" />
              <xs:element name="importe" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnimporte" msprop:Generator_ColumnPropNameInRow="importe" msprop:Generator_ColumnPropNameInTable="importeColumn" msprop:Generator_UserColumnName="importe" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ValesVendidos" msprop:Generator_TableClassName="ValesVendidosDataTable" msprop:Generator_TableVarName="tableValesVendidos" msprop:Generator_RowChangedName="ValesVendidosRowChanged" msprop:Generator_TablePropName="ValesVendidos" msprop:Generator_RowDeletingName="ValesVendidosRowDeleting" msprop:Generator_RowChangingName="ValesVendidosRowChanging" msprop:Generator_RowEvHandlerName="ValesVendidosRowChangeEventHandler" msprop:Generator_RowDeletedName="ValesVendidosRowDeleted" msprop:Generator_RowClassName="ValesVendidosRow" msprop:Generator_UserTableName="ValesVendidos" msprop:Generator_RowEvArgName="ValesVendidosRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="dia" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndia" msprop:Generator_ColumnPropNameInRow="dia" msprop:Generator_ColumnPropNameInTable="diaColumn" msprop:Generator_UserColumnName="dia" type="xs:int" minOccurs="0" />
              <xs:element name="mes" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmes" msprop:Generator_ColumnPropNameInRow="mes" msprop:Generator_ColumnPropNameInTable="mesColumn" msprop:Generator_UserColumnName="mes" type="xs:int" minOccurs="0" />
              <xs:element name="año" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnaño" msprop:Generator_ColumnPropNameInRow="año" msprop:Generator_ColumnPropNameInTable="añoColumn" msprop:Generator_UserColumnName="año" type="xs:int" minOccurs="0" />
              <xs:element name="nombre" msprop:Generator_ColumnVarNameInTable="columnnombre" msprop:Generator_ColumnPropNameInRow="nombre" msprop:Generator_ColumnPropNameInTable="nombreColumn" msprop:Generator_UserColumnName="nombre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cliente" msprop:Generator_ColumnVarNameInTable="columncliente" msprop:Generator_ColumnPropNameInRow="cliente" msprop:Generator_ColumnPropNameInTable="clienteColumn" msprop:Generator_UserColumnName="cliente" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cantidad" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncantidad" msprop:Generator_ColumnPropNameInRow="cantidad" msprop:Generator_ColumnPropNameInTable="cantidadColumn" msprop:Generator_UserColumnName="cantidad" type="xs:int" minOccurs="0" />
              <xs:element name="denominacion" msprop:Generator_ColumnVarNameInTable="columndenominacion" msprop:Generator_ColumnPropNameInRow="denominacion" msprop:Generator_ColumnPropNameInTable="denominacionColumn" msprop:Generator_UserColumnName="denominacion" type="xs:decimal" minOccurs="0" />
              <xs:element name="serie" msprop:Generator_ColumnVarNameInTable="columnserie" msprop:Generator_ColumnPropNameInRow="serie" msprop:Generator_ColumnPropNameInTable="serieColumn" msprop:Generator_UserColumnName="serie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Importe" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnImporte" msprop:Generator_ColumnPropNameInRow="Importe" msprop:Generator_ColumnPropNameInTable="ImporteColumn" msprop:Generator_UserColumnName="Importe" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Encabezado" msprop:Generator_TableClassName="EncabezadoDataTable" msprop:Generator_TableVarName="tableEncabezado" msprop:Generator_RowChangedName="EncabezadoRowChanged" msprop:Generator_TablePropName="Encabezado" msprop:Generator_RowDeletingName="EncabezadoRowDeleting" msprop:Generator_RowChangingName="EncabezadoRowChanging" msprop:Generator_RowEvHandlerName="EncabezadoRowChangeEventHandler" msprop:Generator_RowDeletedName="EncabezadoRowDeleted" msprop:Generator_RowClassName="EncabezadoRow" msprop:Generator_UserTableName="Encabezado" msprop:Generator_RowEvArgName="EncabezadoRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="e1" msprop:Generator_ColumnVarNameInTable="columne1" msprop:Generator_ColumnPropNameInRow="e1" msprop:Generator_ColumnPropNameInTable="e1Column" msprop:Generator_UserColumnName="e1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="43" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="e2" msprop:Generator_ColumnVarNameInTable="columne2" msprop:Generator_ColumnPropNameInRow="e2" msprop:Generator_ColumnPropNameInTable="e2Column" msprop:Generator_UserColumnName="e2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="43" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="e3" msprop:Generator_ColumnVarNameInTable="columne3" msprop:Generator_ColumnPropNameInRow="e3" msprop:Generator_ColumnPropNameInTable="e3Column" msprop:Generator_UserColumnName="e3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="43" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EjercudoDisponible" msprop:Generator_TableClassName="EjercudoDisponibleDataTable" msprop:Generator_TableVarName="tableEjercudoDisponible" msprop:Generator_RowChangedName="EjercudoDisponibleRowChanged" msprop:Generator_TablePropName="EjercudoDisponible" msprop:Generator_RowDeletingName="EjercudoDisponibleRowDeleting" msprop:Generator_RowChangingName="EjercudoDisponibleRowChanging" msprop:Generator_RowEvHandlerName="EjercudoDisponibleRowChangeEventHandler" msprop:Generator_RowDeletedName="EjercudoDisponibleRowDeleted" msprop:Generator_RowClassName="EjercudoDisponibleRow" msprop:Generator_UserTableName="EjercudoDisponible" msprop:Generator_RowEvArgName="EjercudoDisponibleRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="flotilla" msprop:Generator_ColumnVarNameInTable="columnflotilla" msprop:Generator_ColumnPropNameInRow="flotilla" msprop:Generator_ColumnPropNameInTable="flotillaColumn" msprop:Generator_UserColumnName="flotilla" type="xs:int" minOccurs="0" />
              <xs:element name="cliente" msprop:Generator_ColumnVarNameInTable="columncliente" msprop:Generator_ColumnPropNameInRow="cliente" msprop:Generator_ColumnPropNameInTable="clienteColumn" msprop:Generator_UserColumnName="cliente" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TotalVendido" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotalVendido" msprop:Generator_ColumnPropNameInRow="TotalVendido" msprop:Generator_ColumnPropNameInTable="TotalVendidoColumn" msprop:Generator_UserColumnName="TotalVendido" type="xs:decimal" minOccurs="0" />
              <xs:element name="Totalsurtido" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotalsurtido" msprop:Generator_ColumnPropNameInRow="Totalsurtido" msprop:Generator_ColumnPropNameInTable="TotalsurtidoColumn" msprop:Generator_UserColumnName="Totalsurtido" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ClientesConVales" msprop:Generator_TableClassName="ClientesConValesDataTable" msprop:Generator_TableVarName="tableClientesConVales" msprop:Generator_RowChangedName="ClientesConValesRowChanged" msprop:Generator_TablePropName="ClientesConVales" msprop:Generator_RowDeletingName="ClientesConValesRowDeleting" msprop:Generator_RowChangingName="ClientesConValesRowChanging" msprop:Generator_RowEvHandlerName="ClientesConValesRowChangeEventHandler" msprop:Generator_RowDeletedName="ClientesConValesRowDeleted" msprop:Generator_RowClassName="ClientesConValesRow" msprop:Generator_UserTableName="ClientesConVales" msprop:Generator_RowEvArgName="ClientesConValesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="flotilla" msprop:Generator_ColumnVarNameInTable="columnflotilla" msprop:Generator_ColumnPropNameInRow="flotilla" msprop:Generator_ColumnPropNameInTable="flotillaColumn" msprop:Generator_UserColumnName="flotilla" type="xs:int" minOccurs="0" />
              <xs:element name="nombre" msprop:Generator_ColumnVarNameInTable="columnnombre" msprop:Generator_ColumnPropNameInRow="nombre" msprop:Generator_ColumnPropNameInTable="nombreColumn" msprop:Generator_UserColumnName="nombre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ValesEscaneados" msprop:Generator_TableClassName="ValesEscaneadosDataTable" msprop:Generator_TableVarName="tableValesEscaneados" msprop:Generator_RowChangedName="ValesEscaneadosRowChanged" msprop:Generator_TablePropName="ValesEscaneados" msprop:Generator_RowDeletingName="ValesEscaneadosRowDeleting" msprop:Generator_RowChangingName="ValesEscaneadosRowChanging" msprop:Generator_RowEvHandlerName="ValesEscaneadosRowChangeEventHandler" msprop:Generator_RowDeletedName="ValesEscaneadosRowDeleted" msprop:Generator_RowClassName="ValesEscaneadosRow" msprop:Generator_UserTableName="ValesEscaneados" msprop:Generator_RowEvArgName="ValesEscaneadosRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Nums" msprop:Generator_ColumnVarNameInTable="columnNums" msprop:Generator_ColumnPropNameInRow="Nums" msprop:Generator_ColumnPropNameInTable="NumsColumn" msprop:Generator_UserColumnName="Nums" type="xs:string" minOccurs="0" />
              <xs:element name="Foliovale" msprop:Generator_ColumnVarNameInTable="columnFolioVale" msprop:Generator_ColumnPropNameInRow="FolioVale" msprop:Generator_ColumnPropNameInTable="FolioValeColumn" msprop:Generator_UserColumnName="Foliovale" type="xs:string" minOccurs="0" />
              <xs:element name="FechaVenta" msprop:Generator_ColumnVarNameInTable="columnFechaVenta" msprop:Generator_ColumnPropNameInRow="FechaVenta" msprop:Generator_ColumnPropNameInTable="FechaVentaColumn" msprop:Generator_UserColumnName="FechaVenta" type="xs:string" minOccurs="0" />
              <xs:element name="FechaSurtido" msprop:Generator_ColumnVarNameInTable="columnFechaSurtido" msprop:Generator_ColumnPropNameInRow="FechaSurtido" msprop:Generator_ColumnPropNameInTable="FechaSurtidoColumn" msprop:Generator_UserColumnName="FechaSurtido" type="xs:string" default="Desconocido" minOccurs="0" />
              <xs:element name="surtido" msprop:Generator_ColumnVarNameInTable="columnsurtido" msprop:Generator_ColumnPropNameInRow="surtido" msprop:Generator_ColumnPropNameInTable="surtidoColumn" msprop:Generator_UserColumnName="surtido" type="xs:string" minOccurs="0" />
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" type="xs:string" minOccurs="0" />
              <xs:element name="ImpVale" msprop:Generator_ColumnVarNameInTable="columnImpVale" msprop:Generator_ColumnPropNameInRow="ImpVale" msprop:Generator_ColumnPropNameInTable="ImpValeColumn" msprop:Generator_UserColumnName="ImpVale" type="xs:double" minOccurs="0" />
              <xs:element name="Serie" msprop:Generator_ColumnVarNameInTable="columnSerie" msprop:Generator_ColumnPropNameInRow="Serie" msprop:Generator_ColumnPropNameInTable="SerieColumn" msprop:Generator_UserColumnName="Serie" type="xs:string" minOccurs="0" />
              <xs:element name="Cliente" msprop:Generator_ColumnVarNameInTable="columnCliente" msprop:Generator_ColumnPropNameInRow="Cliente" msprop:Generator_ColumnPropNameInTable="ClienteColumn" msprop:Generator_UserColumnName="Cliente" type="xs:string" minOccurs="0" />
              <xs:element name="numvale" msprop:Generator_ColumnVarNameInTable="columnnumvale" msprop:Generator_ColumnPropNameInRow="numvale" msprop:Generator_ColumnPropNameInTable="numvaleColumn" msprop:Generator_UserColumnName="numvale" type="xs:string" minOccurs="0" />
              <xs:element name="Cv" msprop:Generator_ColumnVarNameInTable="columnCv" msprop:Generator_ColumnPropNameInRow="Cv" msprop:Generator_ColumnPropNameInTable="CvColumn" msprop:Generator_UserColumnName="Cv" type="xs:string" minOccurs="0" />
              <xs:element name="Cs" msprop:Generator_ColumnVarNameInTable="columnCs" msprop:Generator_ColumnPropNameInRow="Cs" msprop:Generator_ColumnPropNameInTable="CsColumn" msprop:Generator_UserColumnName="Cs" type="xs:string" minOccurs="0" />
              <xs:element name="EstadoVale" msprop:Generator_ColumnVarNameInTable="columnEstadoVale" msprop:Generator_ColumnPropNameInRow="EstadoVale" msprop:Generator_ColumnPropNameInTable="EstadoValeColumn" msprop:Generator_UserColumnName="EstadoVale" type="xs:string" minOccurs="0" />
              <xs:element name="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" msprop:Generator_UserColumnName="Nombre" type="xs:string" minOccurs="0" />
              <xs:element name="totalsurtido" msprop:Generator_ColumnVarNameInTable="columntotalsurtido" msprop:Generator_ColumnPropNameInRow="totalsurtido" msprop:Generator_ColumnPropNameInTable="totalsurtidoColumn" msprop:Generator_UserColumnName="totalsurtido" type="xs:string" minOccurs="0" />
              <xs:element name="totalnosurtido" msprop:Generator_ColumnVarNameInTable="columntotalnosurtido" msprop:Generator_ColumnPropNameInRow="totalnosurtido" msprop:Generator_ColumnPropNameInTable="totalnosurtidoColumn" msprop:Generator_UserColumnName="totalnosurtido" type="xs:string" minOccurs="0" />
              <xs:element name="FechaLeido" msprop:Generator_ColumnVarNameInTable="columnFechaLeido" msprop:Generator_ColumnPropNameInRow="FechaLeido" msprop:Generator_ColumnPropNameInTable="FechaLeidoColumn" msprop:Generator_UserColumnName="FechaLeido" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Vales" msprop:Generator_TableClassName="ValesDataTable" msprop:Generator_TableVarName="tableVales" msprop:Generator_RowChangedName="ValesRowChanged" msprop:Generator_TablePropName="Vales" msprop:Generator_RowDeletingName="ValesRowDeleting" msprop:Generator_RowChangingName="ValesRowChanging" msprop:Generator_RowEvHandlerName="ValesRowChangeEventHandler" msprop:Generator_RowDeletedName="ValesRowDeleted" msprop:Generator_RowClassName="ValesRow" msprop:Generator_UserTableName="Vales" msprop:Generator_RowEvArgName="ValesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="NumS" msprop:Generator_ColumnVarNameInTable="columnNumS" msprop:Generator_ColumnPropNameInRow="NumS" msprop:Generator_ColumnPropNameInTable="NumSColumn" msprop:Generator_UserColumnName="NumS" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FechaVenta" msprop:Generator_ColumnVarNameInTable="columnFechaVenta" msprop:Generator_ColumnPropNameInRow="FechaVenta" msprop:Generator_ColumnPropNameInTable="FechaVentaColumn" msprop:Generator_UserColumnName="FechaVenta" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FechaSurtido" msprop:Generator_ColumnVarNameInTable="columnFechaSurtido" msprop:Generator_ColumnPropNameInRow="FechaSurtido" msprop:Generator_ColumnPropNameInTable="FechaSurtidoColumn" msprop:Generator_UserColumnName="FechaSurtido" type="xs:dateTime" minOccurs="0" />
              <xs:element name="surtido" msprop:Generator_ColumnVarNameInTable="columnsurtido" msprop:Generator_ColumnPropNameInRow="surtido" msprop:Generator_ColumnPropNameInTable="surtidoColumn" msprop:Generator_UserColumnName="surtido" type="xs:int" minOccurs="0" />
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" type="xs:int" minOccurs="0" />
              <xs:element name="ImpVale" msprop:Generator_ColumnVarNameInTable="columnImpVale" msprop:Generator_ColumnPropNameInRow="ImpVale" msprop:Generator_ColumnPropNameInTable="ImpValeColumn" msprop:Generator_UserColumnName="ImpVale" type="xs:decimal" minOccurs="0" />
              <xs:element name="serie" msprop:Generator_ColumnVarNameInTable="columnserie" msprop:Generator_ColumnPropNameInRow="serie" msprop:Generator_ColumnPropNameInTable="serieColumn" msprop:Generator_UserColumnName="serie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cliente" msprop:Generator_ColumnVarNameInTable="columncliente" msprop:Generator_ColumnPropNameInRow="cliente" msprop:Generator_ColumnPropNameInTable="clienteColumn" msprop:Generator_UserColumnName="cliente" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="numvale" msprop:Generator_ColumnVarNameInTable="columnnumvale" msprop:Generator_ColumnPropNameInRow="numvale" msprop:Generator_ColumnPropNameInTable="numvaleColumn" msprop:Generator_UserColumnName="numvale" type="xs:int" minOccurs="0" />
              <xs:element name="nombre" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnnombre" msprop:Generator_ColumnPropNameInRow="nombre" msprop:Generator_ColumnPropNameInTable="nombreColumn" msprop:Generator_UserColumnName="nombre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="totalsurtido" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntotalsurtido" msprop:Generator_ColumnPropNameInRow="totalsurtido" msprop:Generator_ColumnPropNameInTable="totalsurtidoColumn" msprop:Generator_UserColumnName="totalsurtido" type="xs:decimal" minOccurs="0" />
              <xs:element name="totalnosurtido" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntotalnosurtido" msprop:Generator_ColumnPropNameInRow="totalnosurtido" msprop:Generator_ColumnPropNameInTable="totalnosurtidoColumn" msprop:Generator_UserColumnName="totalnosurtido" type="xs:decimal" minOccurs="0" />
              <xs:element name="Foliovale" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnFoliovale" msprop:Generator_ColumnPropNameInRow="Foliovale" msprop:Generator_ColumnPropNameInTable="FoliovaleColumn" msprop:Generator_UserColumnName="Foliovale" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="72" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FechaLeido" msprop:Generator_ColumnVarNameInTable="columnFechaLeido" msprop:Generator_ColumnPropNameInRow="FechaLeido" msprop:Generator_ColumnPropNameInTable="FechaLeidoColumn" msprop:Generator_UserColumnName="FechaLeido" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="InfoVale" msprop:Generator_TableClassName="InfoValeDataTable" msprop:Generator_TableVarName="tableInfoVale" msprop:Generator_RowChangedName="InfoValeRowChanged" msprop:Generator_TablePropName="InfoVale" msprop:Generator_RowDeletingName="InfoValeRowDeleting" msprop:Generator_RowChangingName="InfoValeRowChanging" msprop:Generator_RowEvHandlerName="InfoValeRowChangeEventHandler" msprop:Generator_RowDeletedName="InfoValeRowDeleted" msprop:Generator_RowClassName="InfoValeRow" msprop:Generator_UserTableName="InfoVale" msprop:Generator_RowEvArgName="InfoValeRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nums" msprop:Generator_ColumnVarNameInTable="columnnums" msprop:Generator_ColumnPropNameInRow="nums" msprop:Generator_ColumnPropNameInTable="numsColumn" msprop:Generator_UserColumnName="nums" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FechaVenta" msprop:Generator_ColumnVarNameInTable="columnFechaVenta" msprop:Generator_ColumnPropNameInRow="FechaVenta" msprop:Generator_ColumnPropNameInTable="FechaVentaColumn" msprop:Generator_UserColumnName="FechaVenta" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FechaSurtido" msprop:Generator_ColumnVarNameInTable="columnFechaSurtido" msprop:Generator_ColumnPropNameInRow="FechaSurtido" msprop:Generator_ColumnPropNameInTable="FechaSurtidoColumn" msprop:Generator_UserColumnName="FechaSurtido" type="xs:dateTime" minOccurs="0" />
              <xs:element name="denominacion" msdata:Caption="ImpVale" msprop:Generator_ColumnVarNameInTable="columndenominacion" msprop:Generator_ColumnPropNameInRow="denominacion" msprop:Generator_ColumnPropNameInTable="denominacionColumn" msprop:Generator_UserColumnName="denominacion" type="xs:decimal" minOccurs="0" />
              <xs:element name="serie" msprop:Generator_ColumnVarNameInTable="columnserie" msprop:Generator_ColumnPropNameInRow="serie" msprop:Generator_ColumnPropNameInTable="serieColumn" msprop:Generator_UserColumnName="serie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cliente" msprop:Generator_ColumnVarNameInTable="columncliente" msprop:Generator_ColumnPropNameInRow="cliente" msprop:Generator_ColumnPropNameInTable="clienteColumn" msprop:Generator_UserColumnName="cliente" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="numvale" msprop:Generator_ColumnVarNameInTable="columnnumvale" msprop:Generator_ColumnPropNameInRow="numvale" msprop:Generator_ColumnPropNameInTable="numvaleColumn" msprop:Generator_UserColumnName="numvale" type="xs:int" minOccurs="0" />
              <xs:element name="Estadovt" msprop:Generator_ColumnVarNameInTable="columnEstadovt" msprop:Generator_ColumnPropNameInRow="Estadovt" msprop:Generator_ColumnPropNameInTable="EstadovtColumn" msprop:Generator_UserColumnName="Estadovt" type="xs:string" minOccurs="0" />
              <xs:element name="surtido" msprop:Generator_ColumnVarNameInTable="columnsurtido" msprop:Generator_ColumnPropNameInRow="surtido" msprop:Generator_ColumnPropNameInTable="surtidoColumn" msprop:Generator_UserColumnName="surtido" type="xs:int" minOccurs="0" />
              <xs:element name="surti" msprop:Generator_ColumnVarNameInTable="columnsurti" msprop:Generator_ColumnPropNameInRow="surti" msprop:Generator_ColumnPropNameInTable="surtiColumn" msprop:Generator_UserColumnName="surti" type="xs:int" minOccurs="0" />
              <xs:element name="Foliovale" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnFoliovale" msprop:Generator_ColumnPropNameInRow="Foliovale" msprop:Generator_ColumnPropNameInTable="FoliovaleColumn" msprop:Generator_UserColumnName="Foliovale" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="72" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Leidos" msprop:Generator_TableClassName="LeidosDataTable" msprop:Generator_TableVarName="tableLeidos" msprop:Generator_RowChangedName="LeidosRowChanged" msprop:Generator_TablePropName="Leidos" msprop:Generator_RowDeletingName="LeidosRowDeleting" msprop:Generator_RowChangingName="LeidosRowChanging" msprop:Generator_RowEvHandlerName="LeidosRowChangeEventHandler" msprop:Generator_RowDeletedName="LeidosRowDeleted" msprop:Generator_RowClassName="LeidosRow" msprop:Generator_UserTableName="Leidos" msprop:Generator_RowEvArgName="LeidosRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Dato" msprop:Generator_ColumnVarNameInTable="columnDato" msprop:Generator_ColumnPropNameInRow="Dato" msprop:Generator_ColumnPropNameInTable="DatoColumn" msprop:Generator_UserColumnName="Dato" type="xs:string" minOccurs="0" />
              <xs:element name="fechaleido" msprop:Generator_ColumnVarNameInTable="columnfechaleido" msprop:Generator_ColumnPropNameInRow="fechaleido" msprop:Generator_ColumnPropNameInTable="fechaleidoColumn" msprop:Generator_UserColumnName="fechaleido" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>